Common tab

Use the Common Tab to select the field you want to group on and specify the sort order for.

Sort Order

This list shows the sort direction options. The default option is in ascending order. If you want to change the sort direction, click the box to reveal other options and make your selection from the list.

Note:    The additional lists for a Date field include choices for grouping by time periods (each week, each month, and so on) and selecting whether to display the first or last date in a period.

Customize Group Name Field

Use this check box if you want to display a name different from the one chosen by default. By default, the group name on the cross-tab is the same as that of the of the column or row you are grouping on. Selecting this check box makes all options below it active.

Choose From Existing Field

Select this option to create a customized group name from an existing database field. For example, your cross-tab may be grouped on Customer ID, but you would rather display the Customer Name.

Use a Formula as Group Name

Select this option to create a customized group name from a formula. Clicking the formula button opens the Group Name Formula Editor.

Related topics

Format Cross-Tab dialog box



Seagate Software IMG Holdings, Inc.
http://www.seagatesoftware.com
Support services:
http://support.seagatesoftware.com